Risc World 3/Risc World 3.iso/SOFTWARE/ISSUE4/POWERBASE/DOCS/_Index

Text File | 2001-03-16 | 19KB | 629 lines

=====
Index
=====

!BMARGIN        55
!BODYFONT       55
!CASE   54
!CHANGE         56
!CLEAR  54
!COMMENT <string>       54
!COPIES         55
!CSV    54
!DATE   55
!DELETE         56
!DESTINATION    55
!EXCLUDE        54
!EXPAND         55
!FILTER         56
!FIRST  55
!FONTSIZE       55
!FORMAT         55
!HEADER, !FOOTER        55
!HEADERFONT     55
!HEADINGS       55
!IMPRESSION     55-56
!INCLUDE        54
!INDEX          56
!INSERT         56
!KEY            56
!LABEL  55
!LINESPACE      55
!LMARGIN        55
!MESSAGE        54
!MOVE   56
!OBEY   56
!ORIENTATION    55
!PAGE   55
!PMARGINS       55
!PRINTOPTS      54
!QUERY  54
!RMARGIN        55
!SAVE   54
!SCRIPT         54
!SELECTION      54
!SHRINK         55
!SORT   55
!SPACER         55
!STARTAT        56
!SUBFILES       54
!TABLE  55
!TEXTWIDTH      55
!TITLE  55
!TMARGIN        55
!UPPER  55

A
=
Access-control list     52
Accumulating records in one subfile     13
Add record button       10, 58, 65
Adding new records      10
Allowed list in validation table        36-39
Alphanumeric fields     29
Altering existing records       11
Analysing Date fields by month  26
Analysing indexed fields        26
AND in search formulae  20
AND, OR and NOT in Help window  23
Application shell, creating     27
Archives, unpacking     5
Arithmetic in search and replace        13
Arithmetic on report columns    42
Arrow keys, action when editing         10
Auto-balancing of indices       51
Average, calculation for numeric column 42

B
=
Balancing indices       51, 60
Batch deletion and moving of records    13
Binary Large Objects (BLOBs)    30
Blanking records on deletion    59
“Bookmarks”, use of to mark place in file       8
Bounding box of field, moving and re-sizing     28
Browsing        8
Button fields on record window  32, 58

C
=
Calculated fields       40-42
Calculation formulae    42
Calculations, general discussion        40
Calculations involving dates    41
Calculations involving times    41
Calculations, making retrospective      40
Case of letters and indexing    35
Case switch (on Query panel)    19, 26
Case switch (on Preferences window)     59
Case-sensitive queries  19, 59
Changing keys   8
Changing many records at once   12
Changing size of database       46, 51
Changing subfile        9
Check Boxes     18, 27, 30, 42, 47
Check boxes, 3-state    18, 30
Check boxes, appearance in reports      18
Choosing which fields to print  18
Clipboard, global       12
Clipboard, use of       12, 65
Closing a database      6
Collecting records in one subfile       13
Colours used to identify key fields     8, 61
Colour used to identify linked fields   37, 61
Colour used to identify mandatory fields        33, 61
Colours window  8, 33, 37, 61
Column calculations     42
Column headings in reports      25
Column spacer   25
Comma, literal, including in search formulae    19
Compacting sequence numbers     32
Comparators in search formulae  19-20, 23
Comparators, list of    20
Comparison by numeric value, forcing    21
Composite fields        41
Computed fields         18, 27, 31, 40-42, 59
Concatenation of fields 17, 45
Confidential data       13-14
Config files, description of    61-62
Config files for individual databases   62
Copy and Paste buttons  12
Copying a field to the clipboard        12
Copying fields  12
Counting matching records       23
Counting values in column       42
CSV data, truncation of         46
CSV field separator     44
CSV file, conversion to functioning database    47
CSV file, edits saved as        59
CSV files       14, 28, 38, 44-48, 51, 53, 57-58
CSV files, description of       44
CSV files from scrollable lists 15
CSV files from validation tables        38
CSV files, importing into scrollable lists      15
CSV files, importing into validation tables     38
CSV header record       44
CSV line terminator     44
CSV options     44-45, 47, 58-60
CSV options, importance of      45
CSVoptions file 59

D
=
Data length for record field    27-28, 32, 50
Data length in scrollable lists         30
Data Merge window       49
Data overflow during CSV import 46
Data underflow during CSV import        46
Data-Merging with other applications    48, 60
Database        33, 43
Database file   7, 14, 31, 50, 59
Database size   33, 46, 51
Database, adding new fields     50
Database, reformatting  50
Database, renaming      35
Database, shortening using subset       57
Date fields     26, 29, 31
Date and time fields    31
Date separator  59
Date stamp fields       26, 32
Date stamp10 fields     32
Date stamp8 fields      32
Date stamp in  report header    25
Day-of-week stamp field 31
Default database, creating      33, 27
Default print options file (!PrintOpts) 26
Default Query file (!Query)     26
Default selection file (!Selection)     18
Delete button   11, 65
Deleting a batch of records     13
Deleting fields during record design    28
Deleting records        11
Descriptors     17, 27-29, 43-44, 46, 50, 55, 59, 61
Dial-tones, generating from records     62
Directory button        32
Directory button, unlinking     33
Disabling certain types of functionality        53, 58
Displayed record, exporting     24
Displayed record, printing      24
Doubled comparators in search formulae  20
Draw files in external fields   14, 30-31
Duplicate keys, warning of      60
Duplicate primary keys, listing of      51
Duplicate primary keys, prohibiting     53

E
=
Editable fields         18, 27, 33
Editing scrollable lists        15
Editing, choosing starting field        12, 60
Email address for Powerbase Support     5
Empty database, building        35
Exact match in table validation 37, 38
Excluding individual records from reports       24
Exit button on record window    32
Expanding data using validation table   25, 39
Expanding report headers        25
ExpandCode (Impulse command)    63-64
Exporting data as CSV files     45
Exporting subsets of records    57
External fields         11, 14, 27, 30-31, 46-47, 60
External fields, editing        14
External fields, exporting      14
External fields, linking files to       14
External fields, pathnames of files     62
External fields, unlinking      14, 31
External fields, warning of deletion from       60
Extra button fields on record window    32

F
=
“Fast forward” button   8, 65
“Fast forward” interval         8
“Fast rewind” button    8, 65
Field, meaning of       7
Field concatenation     17, 49
Field creation in record design 27
Field Definition window         27-28, 50
Field selection for creating reports    17
Field separator in CSV files    44
Fields, copying         12
Fields, making invisible and inaccessible       13
Fields maximum number allowed   61
Fields, printable types 18
Fields, re-ordering     28
File destination for reports    16
File (CSV), conversion to working database      47
Filters         9-10, 65
Filter switch   19, 65
Filetype &7f3, “S” for print Selection  18
Filetype &7f4, “Q”  for Queries 22
Filetype &7f5, “P” for Print options    26
Final record button     8, 65
First record button     8, 65
Fixed data on new records       11
Flashing field, meaning of      9
Footers in reports      25, 42, 55
Force update button     11, 37, 43, 60, 65
Form file       33, 50
Formats for reports     16
Function keys   7, 53, 58
Function keys, assigning        58
Function keys, disabling        53, 58
Function keys, storing strings in       58

G
=
GetExpanded (Impulse command)   63-64
GetField (Impulse command)      63
GetPathname (Impulse command)   63
GetRecord (Impulse command)     63
Global changes  12-13, 19
Global clipboard, support for   12
Grid for designing record layout        27, 50

H
=
Hardware requirements to run Powerbase  5
Headers in reports      25, 46, 55
Header record in CSV file       45, 47
Help application        6
Help available within Powerbase         6, 23
Help window for constructing search formulae    23
Helpreader text         6
Hiding sensitive data   13
Horizontal format for reports   16-17, 25, 55
Hyphen in search formulae       20

I
=
I.D.s and personal passwords    52
Iconbar menu    58
Iconbar menu, disabling         53, 58
Importing data from CSV files   45
Importing data from plain text files    46
Impression, merging data into   48-49, 56, 60
Impulse commands        48-49, 60, 63-64
Including individual records    24
Inclusive search        20
Index, case-sensitive   35
Index, analysing        26
Indexing a field        43
Indices         7-9, 11, 25-27, 35, 43, 50-53, 59-60
Indices directory       27, 43
Inserting fields when designing record  28
Installing Powerbase    5
Internet − special field type   29
Invisible fields        13

K
=
Key fields      7-10, 33-35, 61
Key Structure   33-35, 43, 50
Key structure of the currently-active index     9
Key structure, examples         34-35
Key structure, multiple fields in       35
Key, explanation of     7
Key, inclusion in reports       23
Keypad  7-12, 19, 32, 37-38, 43, 52-53, 58, 60, 65
Keypad buttons as record fields 27
Keypad, disabling       53, 58
Keys    7-9, 34-35, 51, 53, 58, 63
Keys Maximum number     61
Keystrokes      7, 58

L
=
Label format    17
Labels, including primary key   17
Labels, number of lines printed         17
Labels, substituting for blank field    17
Labels, using up part sheets    17
Last altered (stamp field)      32
Launch new copy         59
Line spacing, for tables        17
Line-spacing    17
Linked fields   61
Linking tables to fields        37
List values button      10, 37-38, 65
Loading Powerbase       5
Loading validation tables       39
Logging changes         53
Log file        53
Logo fields     31-32
Lookup function         8

M
=
Mail-Merging    48-49
Main menu, disabling    53, 58
Manager access rights   14
Manager password        52
Mandatory fields        10, 33
Mandatory fields, colouring of  33
Margins in reports      16, 25, 55
Marking records for printing etc.       24
Marking records with “bookmarks”        8
Match window    18-19, 23-24, 32, 54
Matches found during key search, number of      9
Maximum value in column of numbers      42
Maximum value in numeric fields 29
Menu button on screen   33
Menus directory for user menus  27, 33
Merging databases       51
Messages file   62
Minimum value in numeric fields 29
Minimum value in column of numbers      42
Month of year stamp field       32
Months breakdown for Date fields        26
Moving a batch of records       13
Multi-criterion searches        20
Multiple subfiles, use of       9
Multitasking within Powerbase   61

N
=
Naming subfiles         9
New fields, adding to database  50
New record format       50
Next key button         8, 65
Next record button      8, 65
Next subfile button     9, 65
NextMatch (Impulse command)     63-64
NOT in search formulae  20
Null keys in subsidiary indices         43
Null tags, where permitted      29
Numeric fields  13, 25, 29, 35-36, 40-42
Numeric fields in search formulae       21
Numeric fields, justification of        17
Numeric min., start value for Sequence no’s     32

O
=
Old button on Query panel       19
Old button on Search window     10
Open button on Access window    6
Opening a database      6
Options, CSV    44
Options, print  16-17, 23-25
Order of fields in reports      18
OR in search formulae   19-20, 26
Output destination for reports  16
Ovation, mail-merging with      48-49

P
=
Page length in reports  25
Page numbers in reports         25
ParseQuery (Impulse command)    63
Password protection     6, 50, 52-53, 58, 61
Paste from Clipboard    12
Personal I.D.s and passwords    52
Picture fields  14, 30-31
Place in subfile, storing       60
Play button     8
Pop-up menu     33
Powerbase, versions and compatibility   5
Preferences     10, 38, 43, 51, 53, 59-60
Preferences window      29
Previous key button     8, 65
Previous record button  8, 65
Previous subfile button         9, 65
Primary key     7-8, 11, 17, 27, 33-35, 43, 47, 50-51, 53, 60-61, 63
Primary key index       7
Primary key, defining structure         33
PrimaryKey file 33-35, 43, 50
Print button (on screen)        32
Print destination       16-17, 23, 25, 54-56, 62
Print formats   16-18, 24-25
Print Options   16, 24, 26, 39, 44, 46, 58-59
Print options files     26
Print options window, displaying        23-24
Print Resources         18
Print selections        18
Printable fields        18
Printer destination     16
Printing arbitrary selection of records         24
Printing from a Report window   16
Printing order of selected fields       18
Printing speed  26
PrintJobs directory     16, 27, 38, 45-46, 54, 57, 65
PrintRes directory      18, 27, 65
PutRecord (Impulse command)     63-64

Q
=
Query by example (QBE)  19, 22-23
Query by example, limitations of        22-23
Query file, default     21
Query files     22
Query panel     19, 23, 26, 45, 54, 57
Quit button on record window    32
Quitting Powerbase      6
Quotation marks in CSV files    44

R
=
RAM disc        5-6
Random selection of records, printing   24
Re-ordering fields during record design 28
Read password   52
Read/write password     52
Recalculate on opening  59
Record edits as CSV file        59
Record format, minor adjustments to     50
Record layout, designing        27
Record numbers  7, 31
Record numbers, inclusion in reports    23
Record, copying fields  58
Record, copying entire  12
Record terminator in CSV file   44, 45-46
Record window   7, 9-10, 14, 27-28, 30-32, 35, 39, 45-47, 49, 58, 60
Records, filtering      10
Records, retrieving by key      9
Records, retrieving by record number    10
Records, retrieving via Report window   16
Records, searching all subfiles for     10, 58
Records, searching for  9
Related records, accessing      8
Remote fields   14, 30-31
Removing fields during record design    28
Renaming a database     35
Re-ordering fields during record design         28
Replace-on-entry (validation tables)    37-38
Report printing         16, 53
Reporting, disabling    53
Reports, formats for    16
Resources       61
Reverse order for reporting     19
Reverse switch on Query panel   19
Rewind button   8, 65
Rotate button   9, 65
Rotating subfiles       9
Run file button on record window        32
Run file button, unlinking      32

S
=
Save box        16, 27, 38, 58
Saving from a Report window     16
Saving a print selection        18
Saving a query for future use   21-22
Saving print options    26
Script commands         54-56
Script files    46, 54-56, 59
Script language         54
Scrollable list, adding rows    15
Scrollable list, clearing       15
Scrollable list, deleting rows  15
Scrollable list, exporting from         15
Scrollable list, importing to   15
Scrollable lists        18, 24, 27, 29
Scrollable lists and CSV files  45
Scrollable lists and validation tables  37
Scrollable lists, editing       15
Scrollable lists, maximum number of     61
Scrollable lists, printing format       25
Scrollable lists, rows visible  30
Scrollable lists, unequal columns in    30
Scrollable lists, where to use  29
Search all subfiles     58
Search and replace      12
Search button   9, 58, 65
Search element  19, 23
Search formula  10, 12-13, 18-23, 25, 27, 45, 54, 57, 63-64
Search formulae and Help window         23
Search window   9-10
Searching for individual records        9-10, 43
Searching by filter     10
Selection (Impulse command)     63
Self-calculating fields 40, 42
Separator in CSV files  44-45
Sequence number fields  31
Shift back button       11, 65
Shift forward button    11, 65
Shift record forward or backward        11, 65
Shrinking reports (removing white space)        16, 25
Snap interval for record-design grid    27
Sorting 16, 38, 43
Sorting a validation table      38
Sorting lines in a Report window        16
Sorting, specifying before printing     17
Spacer between columns of reports       17, 25, 45, 55
Speeding up printing    26
Sprite files in External fields 14, 18, 30-31
Stamp fields    18, 27, 31-32
Stamp fields, equivalent Computed types  32, 40, 59
Standard deviation, calculation for column      42
Start editing at specified field        12, 60
Stop button     8
Strip leading and trailing spaces       60
Subfile number, inclusion in reports    23
Subfile rotation        9, 65
Subfiles        7, 9-10, 40, 50-51, 53, 60, 65
Subfiles, explanation of        7
Subfiles, naming        9
Subfiles, printing from several         23
Subset database         19, 24, 51, 53, 57
Subsidiary indices      26, 43, 53
Subsidiary keys         7-8, 43
Sum of numbers in report column 42
Swap with button (field definition window)      28

T
=
Table format for reports        17, 25, 55
Tables, maximum number permitted        61
Tag list in search formula      19
Tags    19-20, 23, 27-28, 34, 40-41, 43-44, 46, 48, 50, 55, 63
Tags, importance of     28
Target list in search formula   19
Template, use in data-entry     11
Terminator in CSV files 44-45
Text block      14, 17-18, 25, 28, 30-31, 46
Text button on record window    14
Text files in External fields   14, 30-31
Text width in Vertical format   17, 25
Three-state check-boxes 18, 30
TIME$ in user functions 40-42, 59
Time entry, interpretation of   62
Time fields     29, 31, 41
Time fields, calculations on    41
Time fields, interpretation of input    29, 62
Time fields, separator in       59
Time for report creation        26
Time Stamp fields       31-32
Times, how displayed    62
Title on reports        25
TooBig file and CSV import, explanation of      46
TSV files       44

U
=
Undo facilities 11, 13, 38
Undoing mistakes        11
Unlinking objects from External fields  31
Unlinked validation tables, how to load         39
Unrestricted input fields       29
Upper case in reports   25, 29
User functions  41-42, 59
User menus, defining    33
User menus, where stored        27, 33
UserFuncs file  42
Using CSV files to modify existing records      47
Using more than one subfile     9
UsrSprites file 32

V
=
Validate input button (Preferences)     10, 59-60
Validation      10-12, 25, 36-39, 41, 43, 52, 55, 59-60, 64-65
Validation string in ValStrings file    36
Validation table, creating
Validation table data in printouts      39
Validation table, displaying    38
Validation table, saving contents as CSV file   38
Validation tables, exact match with     37
Validation tables, loading unlinked     39
Validation tables, replace on entry feature     37
Validation, turning ON/OFF      60
ValStrings file         36
ValTables directory     27, 38-39, 65
Vertical format for reports     17, 25, 55

W
=
Website for information & upgrades      5
“White space” in reports, removing      16, 25, 55
Wild cards in search formulae   21
Wild cards in search-and-replace        13
Wild-cards, characters used to represent        59
Window destination for reports  16
Writable icons, copying between 12
Write password  52

Y
=
Year stamp field        32
Yes/No/Maybe fields     29